package com.ruoyi.manager.mapper;

import java.util.List;
import java.util.Map;

/**
 * @author 李红
 * @version 1.0
 * @Description TODO
 * @createTime 2021年09月05日 15:59:00
 */
public interface ITeachAnalysisMapper {

    //在训班级整体信息
    public List<Map<String, Object>> listClassesInfo();

    //当周核心作业完成率
    Map<String, Object> getCoreExCompleteRate();

    //当周核心作业提交率
    Map<String, Object> getCoreExCommitRate();

    //当周核心作业低于40%占比
    Map<String, Object> getCoreExLt40Rate();

    Map<String, Object> getCoreExGt80Rate();

    //统计在训的每个班级当周平均核心作业完成率和提交率
    public List<Map<String,Object>> listCompleteRateSubmitRate();

    //在训各班级当周平均成绩
    public List<Map<String,Object>> listClassesavg();

    public Map<String,Object> listStudentLevelCount();

    public List<Map<String,Object>> listStudentCompleteRatelow40();

    //所有在训班级当周总成绩和平均成绩
    public Map<String,Object> findClassessumandavg();

    public List<Map<String,Object>> listAssessSum();

    public List<Map<String,Object>> listMasterCount();

    public List<Map<String,Object>> listStudentsEmployCityAndSalary();
    public List<Map<String,Object>> listStudentsLocation();
}
